USE mdw
GO

TRUNCATE TABLE custom_snapshots.ssas_command_objects
TRUNCATE TABLE custom_snapshots.ssas_commands
TRUNCATE TABLE custom_snapshots.ssas_connections
TRUNCATE TABLE custom_snapshots.ssas_memory_usage
TRUNCATE TABLE custom_snapshots.ssas_object_activity
TRUNCATE TABLE custom_snapshots.ssas_sessions
TRUNCATE TABLE stage.SSASDMVCommand
TRUNCATE TABLE stage.SSASDMVConnection
TRUNCATE TABLE stage.SSASDMVSession
go
use mdw_control
go
truncate table [mdw].[workload_runs]
